library(tidyverse)
install.packages('nycflights13')
Installing package into <U+393C><U+3E31>C:/Users/clylo/Documents/R/win-library/3.5<U+393C><U+3E32>
(as <U+393C><U+3E31>lib<U+393C><U+3E32> is unspecified)
trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.5/nycflights13_1.0.0.zip'
Content type 'application/zip' length 7110229 bytes (6.8 MB)
downloaded 6.8 MB
package ‘nycflights13’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
C:\Users\clylo\AppData\Local\Temp\RtmpK4rZI8\downloaded_packages
library(nycflights13)
flights
filter(flights, month==1,day==2)
Had an arrival delay of two or more hours
filter(flights,arr_delay > 2)
Flew to Houston (IAH or HOU)
filter(flights,dest == "IAH" | dest == "HOU")
Were operated by United, American, or Delta
unique(flights["carrier"])
filter(flights, carrier == "DL"| carrier == "UA"| carrier == "AA")
Departed in summer (July, August, and September)
filter(flights,month >= 7 ,month <=9)
Arrived more than two hours late, but didn’t leave late
filter(flights, arr_delay > 2, dep_delay <= 0)
Were delayed by at least an hour, but made up over 30 minutes in flight
filter(flights, dep_delay >= 1, dep_delay - arr_delay > 30)
Departed between midnight and 6am (inclusive)
filter(flights, sched_dep_time <= 600 | sched_dep_time == 2400 )
- between() returns if values fall between a range
filter(flights, between(sched_dep_time, 0,600))
filter(flights,is.na(dep_time))
Probably cancellations
- anything to power 0 equals one so not NA
NA^0
[1] 1
5.3.1 1.
arrange(flights, desc(is.na(dep_time)),dep_time)
arrange(flights, desc(dep_delay))
arrange(flights,air_time)
arrange(flights,desc(air_time))
5.4.1 1.
select(flights, dep_time, dep_delay, arr_time, arr_delay)
select(flights,dep_time:arr_time, arr_delay)
select(flights, contains("delay"), contains("time"))
select(flights, arr_time, arr_time)
nothing
vars <- c("year", "month", "day", "dep_delay", "arr_delay")
select(flights,one_of(vars))
one_of matches variable names to those stored in a vector, nice!
select(flights,contains("TIME", ignore.case = FALSE))
yes b/c its not case sensitive just like sql lol
5.5.2 1.
View(flights)
#mutate(flights, = dep_time)
LS0tDQp0aXRsZTogIlI0RFMgQ0g1Ig0Kb3V0cHV0OiBodG1sX25vdGVib29rDQotLS0NCg0KYGBge3J9DQpsaWJyYXJ5KHRpZHl2ZXJzZSkNCmluc3RhbGwucGFja2FnZXMoJ255Y2ZsaWdodHMxMycpDQpgYGANCg0KDQoxLg0KYGBge3J9DQpsaWJyYXJ5KG55Y2ZsaWdodHMxMykNCmZsaWdodHMNCmZpbHRlcihmbGlnaHRzLCBtb250aCA9PSAxLGRheSA9PSAyKQ0KYGBgDQoNCkhhZCBhbiBhcnJpdmFsIGRlbGF5IG9mIHR3byBvciBtb3JlIGhvdXJzDQpgYGB7cn0NCmZpbHRlcihmbGlnaHRzLGFycl9kZWxheSA+IDIpDQpgYGANCg0KRmxldyB0byBIb3VzdG9uIChJQUggb3IgSE9VKQ0KYGBge3J9DQpmaWx0ZXIoZmxpZ2h0cyxkZXN0ID09ICJJQUgiIHwgZGVzdCA9PSAiSE9VIikNCmBgYA0KDQpXZXJlIG9wZXJhdGVkIGJ5IFVuaXRlZCwgQW1lcmljYW4sIG9yIERlbHRhDQpgYGB7cn0NCnVuaXF1ZShmbGlnaHRzWyJjYXJyaWVyIl0pDQpgYGANCmBgYHtyfQ0KZmlsdGVyKGZsaWdodHMsIGNhcnJpZXIgPT0gIkRMInwgY2FycmllciA9PSAiVUEifCBjYXJyaWVyID09ICJBQSIpDQpgYGANCg0KRGVwYXJ0ZWQgaW4gc3VtbWVyIChKdWx5LCBBdWd1c3QsIGFuZCBTZXB0ZW1iZXIpDQpgYGB7cn0NCmZpbHRlcihmbGlnaHRzLG1vbnRoID49IDcgLG1vbnRoIDw9OSkNCmBgYA0KQXJyaXZlZCBtb3JlIHRoYW4gdHdvIGhvdXJzIGxhdGUsIGJ1dCBkaWRuJ3QgbGVhdmUgbGF0ZQ0KYGBge3J9DQpmaWx0ZXIoZmxpZ2h0cywgYXJyX2RlbGF5ID4gMiwgZGVwX2RlbGF5IDw9IDApDQpgYGANCg0KV2VyZSBkZWxheWVkIGJ5IGF0IGxlYXN0IGFuIGhvdXIsIGJ1dCBtYWRlIHVwIG92ZXIgMzAgbWludXRlcyBpbiBmbGlnaHQNCmBgYHtyfQ0KZmlsdGVyKGZsaWdodHMsIGRlcF9kZWxheSA+PSAxLCBkZXBfZGVsYXkgLSBhcnJfZGVsYXkgPiAzMCkNCmBgYA0KDQpEZXBhcnRlZCBiZXR3ZWVuIG1pZG5pZ2h0IGFuZCA2YW0gKGluY2x1c2l2ZSkNCmBgYHtyfQ0KZmlsdGVyKGZsaWdodHMsIHNjaGVkX2RlcF90aW1lIDw9IDYwMCB8IHNjaGVkX2RlcF90aW1lID09IDI0MDAgKQ0KYGBgDQoNCjIuDQpiZXR3ZWVuKCkgcmV0dXJucyBpZiB2YWx1ZXMgZmFsbCBiZXR3ZWVuIGEgcmFuZ2UNCmBgYHtyfQ0KZmlsdGVyKGZsaWdodHMsIGJldHdlZW4oc2NoZWRfZGVwX3RpbWUsIDAsIDYwMCkpDQpgYGANCg0KMy4NCmBgYHtyfQ0KZmlsdGVyKGZsaWdodHMsaXMubmEoZGVwX3RpbWUpKQ0KYGBgDQpQcm9iYWJseSBjYW5jZWxsYXRpb25zDQoNCjQuDQphbnl0aGluZyB0byBwb3dlciAwIGVxdWFscyBvbmUgc28gbm90IE5BDQpgYGB7cn0NCk5BXjANCmBgYA0KDQo1LjMuMQ0KMS4NCmBgYHtyfQ0KYXJyYW5nZShmbGlnaHRzLCBkZXNjKGlzLm5hKGRlcF90aW1lKSksZGVwX3RpbWUpDQpgYGANCg0KMi4NCmBgYHtyfQ0KYXJyYW5nZShmbGlnaHRzLCBkZXNjKGRlcF9kZWxheSkpDQpgYGANCg0KMy4NCmBgYHtyfQ0KYXJyYW5nZShmbGlnaHRzLGFpcl90aW1lKQ0KYXJyYW5nZShmbGlnaHRzLGRlc2MoYWlyX3RpbWUpKQ0KYGBgDQoNCjUuNC4xDQoxLg0KYGBge3J9DQpzZWxlY3QoZmxpZ2h0cywgZGVwX3RpbWUsIGRlcF9kZWxheSwgYXJyX3RpbWUsIGFycl9kZWxheSkNCg0KDQpgYGANCg0KYGBge3J9DQpzZWxlY3QoZmxpZ2h0cyxkZXBfdGltZTphcnJfdGltZSwgYXJyX2RlbGF5KQ0KYGBgDQoNCmBgYHtyfQ0Kc2VsZWN0KGZsaWdodHMsIGNvbnRhaW5zKCJkZWxheSIpLCBjb250YWlucygidGltZSIpKQ0KYGBgDQoNCjIuDQpgYGB7cn0NCnNlbGVjdChmbGlnaHRzLCBhcnJfdGltZSwgYXJyX3RpbWUpDQpgYGANCg0Kbm90aGluZw0KDQozLg0KYGBge3J9DQp2YXJzIDwtIGMoInllYXIiLCAibW9udGgiLCAiZGF5IiwgImRlcF9kZWxheSIsICJhcnJfZGVsYXkiKQ0Kc2VsZWN0KGZsaWdodHMsb25lX29mKHZhcnMpKQ0KYGBgDQoNCm9uZV9vZiBtYXRjaGVzIHZhcmlhYmxlIG5hbWVzIHRvIHRob3NlIHN0b3JlZCBpbiBhIHZlY3RvciwgbmljZSENCg0KNC4NCmBgYHtyfQ0Kc2VsZWN0KGZsaWdodHMsY29udGFpbnMoIlRJTUUiLCBpZ25vcmUuY2FzZSA9IEZBTFNFKSkNCmBgYA0KDQp5ZXMgYi9jIGl0cyBub3QgY2FzZSBzZW5zaXRpdmUganVzdCBsaWtlIHNxbCBsb2wNCg0KNS41LjINCjEuDQpgYGB7cn0NClZpZXcoZmxpZ2h0cykNCiNtdXRhdGUoZmxpZ2h0cywgID0gZGVwX3RpbWUpDQpgYGANCg0K